package com.tina.mapper;

import com.tina.entity.TiSlideshow;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.tina.entity.vo.TiSlideshowVo;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 * 画廊 Mapper 接口
 * </p>
 *
 * @author PIGS
 * @since 2020-06-05
 */
public interface TiSlideshowMapper extends BaseMapper<TiSlideshow> {

    /**
     * 查询图片
     * @return
     */
    @Select("select slideshow_id as pid, slideshow_name as alt, slideshow_img as src,slideshow_thumb as thumb from ti_slideshow where slideshow_state=0 order by slideshow_time desc ")
    List<TiSlideshowVo> querySlideshow();

}
